// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_HR_FORMAL_APPLICATION
// * CreateDate    : 2014-06-05 18:30:04
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:04
// * LastChanger   : 2014-06-05 18:30:04
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class HrFormalApplicationTable : TableInfo
    {
		public const string C_TableName = "HR_FORMAL_APPLICATION";
		
		public const string C_APPLICATION_ID = "APPLICATION_ID";
		public const string C_DEPARTMENT_ID = "DEPARTMENT_ID";
		public const string C_PERSON_ID = "PERSON_ID";
		public const string C_POSITION_ID = "POSITION_ID";
		public const string C_APPLICATION_DATE = "APPLICATION_DATE";
		public const string C_FORMAL_REASON = "FORMAL_REASON";
		public const string C_DM_REMARK = "DM_REMARK";
		public const string C_DM_PERSON = "DM_PERSON";
		public const string C_DM_APPROVED_DATE = "DM_APPROVED_DATE";
		public const string C_HR_REMARK = "HR_REMARK";
		public const string C_HR_PERSON = "HR_PERSON";
		public const string C_HR_APPROVED_DATE = "HR_APPROVED_DATE";
		public const string C_CEO_REMARK = "CEO_REMARK";
		public const string C_CEO_PERSON = "CEO_PERSON";
		public const string C_CEO_APPROVED_DATE = "CEO_APPROVED_DATE";
		public const string C_REMARK = "REMARK";
		public const string C_STATUS = "STATUS";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
		
		public HrFormalApplicationTable()
        {
            _tableName = "HR_FORMAL_APPLICATION";
        }
		
		protected static HrFormalApplicationTable _current;
        public static HrFormalApplicationTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new HrFormalApplicationTable();

            _current.Add(C_APPLICATION_ID, new ColumnInfo(C_APPLICATION_ID,"ApplicationId", true, typeof(string)));
            _current.Add(C_DEPARTMENT_ID, new ColumnInfo(C_DEPARTMENT_ID,"DepartmentId", false, typeof(string)));
            _current.Add(C_PERSON_ID, new ColumnInfo(C_PERSON_ID,"PersonId", false, typeof(string)));
            _current.Add(C_POSITION_ID, new ColumnInfo(C_POSITION_ID,"PositionId", false, typeof(string)));
            _current.Add(C_APPLICATION_DATE, new ColumnInfo(C_APPLICATION_DATE,"ApplicationDate", false, typeof(DateTime)));
            _current.Add(C_FORMAL_REASON, new ColumnInfo(C_FORMAL_REASON,"FormalReason", false, typeof(string)));
            _current.Add(C_DM_REMARK, new ColumnInfo(C_DM_REMARK,"DmRemark", false, typeof(string)));
            _current.Add(C_DM_PERSON, new ColumnInfo(C_DM_PERSON,"DmPerson", false, typeof(string)));
            _current.Add(C_DM_APPROVED_DATE, new ColumnInfo(C_DM_APPROVED_DATE,"DmApprovedDate", false, typeof(DateTime)));
            _current.Add(C_HR_REMARK, new ColumnInfo(C_HR_REMARK,"HrRemark", false, typeof(string)));
            _current.Add(C_HR_PERSON, new ColumnInfo(C_HR_PERSON,"HrPerson", false, typeof(string)));
            _current.Add(C_HR_APPROVED_DATE, new ColumnInfo(C_HR_APPROVED_DATE,"HrApprovedDate", false, typeof(DateTime)));
            _current.Add(C_CEO_REMARK, new ColumnInfo(C_CEO_REMARK,"CeoRemark", false, typeof(string)));
            _current.Add(C_CEO_PERSON, new ColumnInfo(C_CEO_PERSON,"CeoPerson", false, typeof(string)));
            _current.Add(C_CEO_APPROVED_DATE, new ColumnInfo(C_CEO_APPROVED_DATE,"CeoApprovedDate", false, typeof(DateTime)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
			
		}
		
		public ColumnInfo APPLICATION_ID
        {
            get { return this[C_APPLICATION_ID]; }
        }
		
		public ColumnInfo DEPARTMENT_ID
        {
            get { return this[C_DEPARTMENT_ID]; }
        }
		
		public ColumnInfo PERSON_ID
        {
            get { return this[C_PERSON_ID]; }
        }
		
		public ColumnInfo POSITION_ID
        {
            get { return this[C_POSITION_ID]; }
        }
		
		public ColumnInfo APPLICATION_DATE
        {
            get { return this[C_APPLICATION_DATE]; }
        }
		
		public ColumnInfo FORMAL_REASON
        {
            get { return this[C_FORMAL_REASON]; }
        }
		
		public ColumnInfo DM_REMARK
        {
            get { return this[C_DM_REMARK]; }
        }
		
		public ColumnInfo DM_PERSON
        {
            get { return this[C_DM_PERSON]; }
        }
		
		public ColumnInfo DM_APPROVED_DATE
        {
            get { return this[C_DM_APPROVED_DATE]; }
        }
		
		public ColumnInfo HR_REMARK
        {
            get { return this[C_HR_REMARK]; }
        }
		
		public ColumnInfo HR_PERSON
        {
            get { return this[C_HR_PERSON]; }
        }
		
		public ColumnInfo HR_APPROVED_DATE
        {
            get { return this[C_HR_APPROVED_DATE]; }
        }
		
		public ColumnInfo CEO_REMARK
        {
            get { return this[C_CEO_REMARK]; }
        }
		
		public ColumnInfo CEO_PERSON
        {
            get { return this[C_CEO_PERSON]; }
        }
		
		public ColumnInfo CEO_APPROVED_DATE
        {
            get { return this[C_CEO_APPROVED_DATE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }
		
		
		
	}
}

